namespace EFMysql
{
    using System;
    using System.Collections.Generic;
    using System.ComponentModel.DataAnnotations;
    using System.ComponentModel.DataAnnotations.Schema;
    using System.Data.Entity.Spatial;

    [Table("www_test.pre_order_copy")]
    public partial class pre_order_copy
    {
        [Key]
        [Column(TypeName = "uint")]
        public long orderid { get; set; }

        public int shopid { get; set; }

        public bool status { get; set; }

        [StringLength(1000)]
        public string link { get; set; }

        public byte number { get; set; }

        public bool type { get; set; }

        [StringLength(255)]
        public string keyword { get; set; }

        [StringLength(255)]
        public string position { get; set; }

        [StringLength(255)]
        public string comment { get; set; }

        [StringLength(1000)]
        public string remark { get; set; }

        [Column(TypeName = "uint")]
        public long yuyuetime { get; set; }

        [Column(TypeName = "uint")]
        public long userid { get; set; }

        [StringLength(20)]
        public string orderno { get; set; }

        [StringLength(20)]
        public string mailno { get; set; }

        [StringLength(20)]
        public string mailtype { get; set; }

        [Column(TypeName = "uint")]
        public long receivetime { get; set; }

        [Column(TypeName = "text")]
        [StringLength(65535)]
        public string address { get; set; }

        [Column(TypeName = "text")]
        [StringLength(65535)]
        public string cmnremark { get; set; }

        [Column(TypeName = "uint")]
        public long createtime { get; set; }

        [Column(TypeName = "uint")]
        public long? updatetime { get; set; }

        [Column(TypeName = "uint")]
        public long createid { get; set; }

        [Column(TypeName = "uint")]
        public long? updateid { get; set; }

        public int? buytime { get; set; }

        public int? yundantime { get; set; }

        public int? fukuantime { get; set; }

        public int? pingjiatime { get; set; }

        [StringLength(255)]
        public string buyername { get; set; }

        [StringLength(255)]
        public string nation { get; set; }

        [StringLength(255)]
        public string buyerno { get; set; }

        public decimal? percommition { get; set; }

        public decimal? perorderprice { get; set; }

        public decimal? rateval { get; set; }

        public decimal? mobilefee { get; set; }

        [StringLength(100)]
        public string SKU { get; set; }

        [StringLength(20)]
        public string mailname { get; set; }

        [StringLength(100)]
        public string mailstreet { get; set; }

        [StringLength(20)]
        public string mailcity { get; set; }

        [StringLength(20)]
        public string mailstate { get; set; }

        [StringLength(20)]
        public string mailnation { get; set; }

        [StringLength(20)]
        public string mailpcode { get; set; }

        [StringLength(20)]
        public string mailphone { get; set; }

        [StringLength(20)]
        public string contacttel { get; set; }

        [StringLength(20)]
        public string TrancationID { get; set; }

        [StringLength(20)]
        public string productid { get; set; }

        public int? mailnotype { get; set; }

        [StringLength(1073741823)]
        public string markup { get; set; }
    }
}
